Module 2 of Path: Become a Database Professional with SQL
An Introductory Guide to SQL
Module Overview
The ability to work SQL is becoming an increasingly in-demand skill, both for software developers and people in less technical roles. If you’re interested in learning SQL and have no prior experience with it, then this module will be your light in a dark tunnel. You’ll start by covering the basics of SQL such as how to create a database, and how to insert, query, and update data. You’ll also learn fundamental concepts that developers and data scientists use everyday such as multi-table operations, nested queries, and how to set up views. Throughout, you’ll get to execute SQL queries in your browser and see results in real-time - you won’t need to worry about set-up. At the end of this module, you’ll also get some hands-on practice with common SQL interview questions, so when the time comes, you’ll be ready and confident to answer any question that comes your way. Let’s get started!
Module Objectives
Learn multiple queries in SQL.
Learn to execute SQL queries in your browser.
Get some hands-on practice with common SQL interview questions.
98 Lessons
146 Quizzes
144 Playgrounds
1016 Code Snippets
672 Illustrations
2. Basic SQL
Exploring MySQL
Create Database
Data Types
Create Table
... continue
Temporary Table
Collations & Character Sets
Inserting Data
Querying Data
LIKE Operator
Combining Conditions
ORDER BY
LIMIT
Deleting Data
TRUNCATE
Updating Data
Primary Key and Indexes
... continued
Alterations
Alter Index
More on Alter
Alias
DISTINCT
Aggregate Methods
GROUP BY
HAVING
4. Nested Queries
5. Multi Table Operations
6. Views
7. Stored Procedures
8. Triggers
9. Miscellaneous
10. Practice & Prep
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5
Quiz 6
Quiz 7
Quiz 8
Quiz 9
Quiz 10
Quiz 11
Quiz 12
Quiz 13
Quiz 14
Quiz 15
Quiz 16
Practice Set 1
Solution Practice Set 1
Practice Set 2
Solution Practice Set 2
Practice Set 3
Solution Practice Set 3
Practice Set 4
Solution Practice Set 4
Practice Set 5
Solution Practice Set 5
Practice Set 6
Solution Practice Set 6
Cheat Sheet
11. Conclusion
98 Lessons
146 Quizzes
144 Playgrounds
1016 Code Snippets
672 Illustrations
